Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 51290 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 8.2 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Text | 6 |
|---|---|
| Unsupported | 2 |
| Categorical | 8 |
| Numeric | 5 |
category is highly overall correlated with sub_category | High correlation |
discount is highly overall correlated with profit | High correlation |
market is highly overall correlated with region | High correlation |
profit is highly overall correlated with discount | High correlation |
region is highly overall correlated with market | High correlation |
sales is highly overall correlated with shipping_cost | High correlation |
shipping_cost is highly overall correlated with sales | High correlation |
sub_category is highly overall correlated with category | High correlation |
order_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ship_date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
discount has 29009 (56.6%) zeros | Zeros |
profit has 668 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-10-14 07:21:58.630641 |
|---|---|
| Analysis finished | 2025-10-14 07:22:14.799347 |
| Duration | 16.17 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
order_id
Text
| Distinct | 25035 |
|---|---|
| Distinct (%) | 48.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 13.569643 |
| Min length | 9 |
Unique
| Unique | 12257 ? |
|---|---|
| Unique (%) | 23.9% |
Sample
| 1st row | AG-2011-2040 |
|---|---|
| 2nd row | IN-2011-47883 |
| 3rd row | HU-2011-1220 |
| 4th row | IT-2011-3647632 |
| 5th row | IN-2011-47883 |
| Value | Count | Frequency (%) |
| ca-2014-100111 | 14 | < 0.1% |
| to-2014-9950 | 13 | < 0.1% |
| ni-2014-8880 | 13 | < 0.1% |
| in-2013-42311 | 13 | < 0.1% |
| in-2012-41261 | 13 | < 0.1% |
| mx-2014-166541 | 13 | < 0.1% |
| in-2011-76625 | 12 | < 0.1% |
| es-2012-5776825 | 12 | < 0.1% |
| in-2014-15263 | 12 | < 0.1% |
| mx-2013-142678 | 12 | < 0.1% |
| Other values (25025) | 51163 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 108762 | |
| - | 102580 | |
| 2 | 90147 | |
| 0 | 85011 | |
| 4 | 45213 | 6.5% |
| 3 | 41592 | 6.0% |
| 5 | 27294 | 3.9% |
| 6 | 25799 | 3.7% |
| 7 | 23086 | 3.3% |
| 8 | 22626 | 3.3% |
| Other values (27) | 123877 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 695987 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 108762 | |
| - | 102580 | |
| 2 | 90147 | |
| 0 | 85011 | |
| 4 | 45213 | 6.5% |
| 3 | 41592 | 6.0% |
| 5 | 27294 | 3.9% |
| 6 | 25799 | 3.7% |
| 7 | 23086 | 3.3% |
| 8 | 22626 | 3.3% |
| Other values (27) | 123877 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 695987 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 108762 | |
| - | 102580 | |
| 2 | 90147 | |
| 0 | 85011 | |
| 4 | 45213 | 6.5% |
| 3 | 41592 | 6.0% |
| 5 | 27294 | 3.9% |
| 6 | 25799 | 3.7% |
| 7 | 23086 | 3.3% |
| 8 | 22626 | 3.3% |
| Other values (27) | 123877 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 695987 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 108762 | |
| - | 102580 | |
| 2 | 90147 | |
| 0 | 85011 | |
| 4 | 45213 | 6.5% |
| 3 | 41592 | 6.0% |
| 5 | 27294 | 3.9% |
| 6 | 25799 | 3.7% |
| 7 | 23086 | 3.3% |
| 8 | 22626 | 3.3% |
| Other values (27) | 123877 |
order_date
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
ship_date
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
ship_mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 2701 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.843069 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard Class |
|---|---|
| 2nd row | Standard Class |
| 3rd row | Second Class |
| 4th row | Second Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 30775 | |
| Second Class | 10309 | 20.1% |
| First Class | 7505 | 14.6% |
| Same Day | 2701 | 5.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 48589 | |
| standard | 30775 | |
| second | 10309 | 10.0% |
| first | 7505 | 7.3% |
| same | 2701 | 2.6% |
| day | 2701 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 115541 | |
| s | 104683 | |
| d | 71859 | |
| 51290 | ||
| l | 48589 | |
| C | 48589 | |
| S | 43785 | 6.6% |
| n | 41084 | 6.2% |
| r | 38280 | 5.8% |
| t | 38280 | 5.8% |
| Other values (8) | 56741 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 658721 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 115541 | |
| s | 104683 | |
| d | 71859 | |
| 51290 | ||
| l | 48589 | |
| C | 48589 | |
| S | 43785 | 6.6% |
| n | 41084 | 6.2% |
| r | 38280 | 5.8% |
| t | 38280 | 5.8% |
| Other values (8) | 56741 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 658721 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 115541 | |
| s | 104683 | |
| d | 71859 | |
| 51290 | ||
| l | 48589 | |
| C | 48589 | |
| S | 43785 | 6.6% |
| n | 41084 | 6.2% |
| r | 38280 | 5.8% |
| t | 38280 | 5.8% |
| Other values (8) | 56741 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 658721 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 115541 | |
| s | 104683 | |
| d | 71859 | |
| 51290 | ||
| l | 48589 | |
| C | 48589 | |
| S | 43785 | 6.6% |
| n | 41084 | 6.2% |
| r | 38280 | 5.8% |
| t | 38280 | 5.8% |
| Other values (8) | 56741 |
customer_name
Text
| Distinct | 795 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.946227 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Toby Braunhardt |
|---|---|
| 2nd row | Joseph Holt |
| 3rd row | Annie Thurman |
| 4th row | Eugene Moren |
| 5th row | Joseph Holt |
| Value | Count | Frequency (%) |
| michael | 655 | 0.6% |
| john | 522 | 0.5% |
| paul | 438 | 0.4% |
| patrick | 437 | 0.4% |
| tom | 430 | 0.4% |
| stewart | 426 | 0.4% |
| anthony | 424 | 0.4% |
| frank | 422 | 0.4% |
| bill | 402 | 0.4% |
| alan | 402 | 0.4% |
| Other values (901) | 98324 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 61455 | 9.3% |
| e | 60921 | 9.2% |
| n | 51801 | 7.8% |
| 51592 | 7.8% | |
| r | 48359 | 7.3% |
| i | 40342 | 6.1% |
| l | 34229 | 5.2% |
| o | 30793 | 4.6% |
| t | 27197 | 4.1% |
| s | 23187 | 3.5% |
| Other values (47) | 234136 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 664012 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 61455 | 9.3% |
| e | 60921 | 9.2% |
| n | 51801 | 7.8% |
| 51592 | 7.8% | |
| r | 48359 | 7.3% |
| i | 40342 | 6.1% |
| l | 34229 | 5.2% |
| o | 30793 | 4.6% |
| t | 27197 | 4.1% |
| s | 23187 | 3.5% |
| Other values (47) | 234136 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 664012 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 61455 | 9.3% |
| e | 60921 | 9.2% |
| n | 51801 | 7.8% |
| 51592 | 7.8% | |
| r | 48359 | 7.3% |
| i | 40342 | 6.1% |
| l | 34229 | 5.2% |
| o | 30793 | 4.6% |
| t | 27197 | 4.1% |
| s | 23187 | 3.5% |
| Other values (47) | 234136 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 664012 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 61455 | 9.3% |
| e | 60921 | 9.2% |
| n | 51801 | 7.8% |
| 51592 | 7.8% | |
| r | 48359 | 7.3% |
| i | 40342 | 6.1% |
| l | 34229 | 5.2% |
| o | 30793 | 4.6% |
| t | 27197 | 4.1% |
| s | 23187 | 3.5% |
| Other values (47) | 234136 |
segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8472997 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Consumer |
| 4th row | Home Office |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 26518 | |
| Corporate | 15429 | |
| Home Office | 9343 | 18.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 26518 | |
| corporate | 15429 | |
| home | 9343 | 15.4% |
| office | 9343 | 15.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 66719 | |
| e | 60633 | |
| r | 57376 | |
| C | 41947 | |
| m | 35861 | |
| n | 26518 | 5.8% |
| s | 26518 | 5.8% |
| u | 26518 | 5.8% |
| f | 18686 | 4.1% |
| t | 15429 | 3.4% |
| Other values (7) | 77573 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 453778 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 66719 | |
| e | 60633 | |
| r | 57376 | |
| C | 41947 | |
| m | 35861 | |
| n | 26518 | 5.8% |
| s | 26518 | 5.8% |
| u | 26518 | 5.8% |
| f | 18686 | 4.1% |
| t | 15429 | 3.4% |
| Other values (7) | 77573 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 453778 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 66719 | |
| e | 60633 | |
| r | 57376 | |
| C | 41947 | |
| m | 35861 | |
| n | 26518 | 5.8% |
| s | 26518 | 5.8% |
| u | 26518 | 5.8% |
| f | 18686 | 4.1% |
| t | 15429 | 3.4% |
| Other values (7) | 77573 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 453778 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 66719 | |
| e | 60633 | |
| r | 57376 | |
| C | 41947 | |
| m | 35861 | |
| n | 26518 | 5.8% |
| s | 26518 | 5.8% |
| u | 26518 | 5.8% |
| f | 18686 | 4.1% |
| t | 15429 | 3.4% |
| Other values (7) | 77573 |
state
Text
| Distinct | 1094 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 26 |
| Mean length | 9.6409826 |
| Min length | 3 |
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Constantine |
|---|---|
| 2nd row | New South Wales |
| 3rd row | Budapest |
| 4th row | Stockholm |
| 5th row | New South Wales |
| Value | Count | Frequency (%) |
| california | 2125 | 3.1% |
| new | 2103 | 3.1% |
| england | 1499 | 2.2% |
| south | 1201 | 1.8% |
| north | 1145 | 1.7% |
| york | 1128 | 1.7% |
| texas | 985 | 1.4% |
| ile-de-france | 981 | 1.4% |
| wales | 817 | 1.2% |
| capital | 784 | 1.1% |
| Other values (1189) | 55429 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 72974 | |
| n | 39413 | 8.0% |
| i | 33410 | 6.8% |
| e | 30993 | 6.3% |
| o | 28369 | 5.7% |
| r | 28361 | 5.7% |
| l | 23890 | 4.8% |
| t | 21263 | 4.3% |
| s | 19509 | 3.9% |
| 16907 | 3.4% | |
| Other values (71) | 179397 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 494486 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 72974 | |
| n | 39413 | 8.0% |
| i | 33410 | 6.8% |
| e | 30993 | 6.3% |
| o | 28369 | 5.7% |
| r | 28361 | 5.7% |
| l | 23890 | 4.8% |
| t | 21263 | 4.3% |
| s | 19509 | 3.9% |
| 16907 | 3.4% | |
| Other values (71) | 179397 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 494486 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 72974 | |
| n | 39413 | 8.0% |
| i | 33410 | 6.8% |
| e | 30993 | 6.3% |
| o | 28369 | 5.7% |
| r | 28361 | 5.7% |
| l | 23890 | 4.8% |
| t | 21263 | 4.3% |
| s | 19509 | 3.9% |
| 16907 | 3.4% | |
| Other values (71) | 179397 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 494486 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 72974 | |
| n | 39413 | 8.0% |
| i | 33410 | 6.8% |
| e | 30993 | 6.3% |
| o | 28369 | 5.7% |
| r | 28361 | 5.7% |
| l | 23890 | 4.8% |
| t | 21263 | 4.3% |
| s | 19509 | 3.9% |
| 16907 | 3.4% | |
| Other values (71) | 179397 |
country
Text
| Distinct | 147 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 8.8366738 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Algeria |
|---|---|
| 2nd row | Australia |
| 3rd row | Hungary |
| 4th row | Sweden |
| 5th row | Australia |
| Value | Count | Frequency (%) |
| united | 11641 | 17.1% |
| states | 9994 | 14.7% |
| australia | 2837 | 4.2% |
| france | 2827 | 4.2% |
| mexico | 2644 | 3.9% |
| germany | 2065 | 3.0% |
| china | 1880 | 2.8% |
| kingdom | 1633 | 2.4% |
| brazil | 1599 | 2.3% |
| india | 1555 | 2.3% |
| Other values (154) | 29420 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 55137 | 12.2% |
| e | 43176 | 9.5% |
| i | 40575 | 9.0% |
| t | 40485 | 8.9% |
| n | 36881 | 8.1% |
| d | 21302 | 4.7% |
| r | 20390 | 4.5% |
| s | 18355 | 4.0% |
| 16805 | 3.7% | |
| o | 14461 | 3.2% |
| Other values (44) | 145666 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 453233 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 55137 | 12.2% |
| e | 43176 | 9.5% |
| i | 40575 | 9.0% |
| t | 40485 | 8.9% |
| n | 36881 | 8.1% |
| d | 21302 | 4.7% |
| r | 20390 | 4.5% |
| s | 18355 | 4.0% |
| 16805 | 3.7% | |
| o | 14461 | 3.2% |
| Other values (44) | 145666 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 453233 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 55137 | 12.2% |
| e | 43176 | 9.5% |
| i | 40575 | 9.0% |
| t | 40485 | 8.9% |
| n | 36881 | 8.1% |
| d | 21302 | 4.7% |
| r | 20390 | 4.5% |
| s | 18355 | 4.0% |
| 16805 | 3.7% | |
| o | 14461 | 3.2% |
| Other values (44) | 145666 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 453233 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 55137 | 12.2% |
| e | 43176 | 9.5% |
| i | 40575 | 9.0% |
| t | 40485 | 8.9% |
| n | 36881 | 8.1% |
| d | 21302 | 4.7% |
| r | 20390 | 4.5% |
| s | 18355 | 4.0% |
| 16805 | 3.7% | |
| o | 14461 | 3.2% |
| Other values (44) | 145666 |
market
Categorical
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| APAC | |
|---|---|
| LATAM | |
| EU | |
| US | |
| EMEA | |
| Other values (2) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 3.6148957 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Africa |
|---|---|
| 2nd row | APAC |
| 3rd row | EMEA |
| 4th row | EU |
| 5th row | APAC |
Common Values
| Value | Count | Frequency (%) |
| APAC | 11002 | |
| LATAM | 10294 | |
| EU | 10000 | |
| US | 9994 | |
| EMEA | 5029 | |
| Africa | 4587 | |
| Canada | 384 | 0.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| apac | 11002 | |
| latam | 10294 | |
| eu | 10000 | |
| us | 9994 | |
| emea | 5029 | |
| africa | 4587 | |
| canada | 384 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 52208 | |
| E | 20058 | 10.8% |
| U | 19994 | 10.8% |
| M | 15323 | 8.3% |
| C | 11386 | 6.1% |
| P | 11002 | 5.9% |
| L | 10294 | 5.6% |
| T | 10294 | 5.6% |
| S | 9994 | 5.4% |
| a | 5739 | 3.1% |
| Other values (6) | 19116 | 10.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 185408 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 52208 | |
| E | 20058 | 10.8% |
| U | 19994 | 10.8% |
| M | 15323 | 8.3% |
| C | 11386 | 6.1% |
| P | 11002 | 5.9% |
| L | 10294 | 5.6% |
| T | 10294 | 5.6% |
| S | 9994 | 5.4% |
| a | 5739 | 3.1% |
| Other values (6) | 19116 | 10.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 185408 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 52208 | |
| E | 20058 | 10.8% |
| U | 19994 | 10.8% |
| M | 15323 | 8.3% |
| C | 11386 | 6.1% |
| P | 11002 | 5.9% |
| L | 10294 | 5.6% |
| T | 10294 | 5.6% |
| S | 9994 | 5.4% |
| a | 5739 | 3.1% |
| Other values (6) | 19116 | 10.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 185408 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 52208 | |
| E | 20058 | 10.8% |
| U | 19994 | 10.8% |
| M | 15323 | 8.3% |
| C | 11386 | 6.1% |
| P | 11002 | 5.9% |
| L | 10294 | 5.6% |
| T | 10294 | 5.6% |
| S | 9994 | 5.4% |
| a | 5739 | 3.1% |
| Other values (6) | 19116 | 10.3% |
region
Categorical
High correlation 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| Central | |
|---|---|
| South | |
| EMEA | |
| North | |
| Africa | |
| Other values (8) |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 6.638643 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Africa |
|---|---|
| 2nd row | Oceania |
| 3rd row | EMEA |
| 4th row | North |
| 5th row | Oceania |
Common Values
| Value | Count | Frequency (%) |
| Central | 11117 | |
| South | 6645 | |
| EMEA | 5029 | |
| North | 4785 | |
| Africa | 4587 | |
| Oceania | 3487 | 6.8% |
| West | 3203 | 6.2% |
| Southeast Asia | 3129 | 6.1% |
| East | 2848 | 5.6% |
| North Asia | 2338 | 4.6% |
| Other values (3) | 4122 | 8.0% |
Length
| Value | Count | Frequency (%) |
| central | 13165 | |
| asia | 7515 | |
| north | 7123 | |
| south | 6645 | |
| emea | 5029 | 8.6% |
| africa | 4587 | 7.8% |
| oceania | 3487 | 5.9% |
| west | 3203 | 5.4% |
| southeast | 3129 | 5.3% |
| east | 2848 | 4.8% |
| Other values (2) | 2074 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 42750 | |
| t | 39242 | 11.5% |
| r | 26565 | 7.8% |
| e | 24674 | 7.2% |
| n | 18726 | 5.5% |
| i | 17279 | 5.1% |
| A | 17131 | 5.0% |
| o | 16897 | 5.0% |
| h | 16897 | 5.0% |
| s | 16695 | 4.9% |
| Other values (14) | 103640 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 340496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 42750 | |
| t | 39242 | 11.5% |
| r | 26565 | 7.8% |
| e | 24674 | 7.2% |
| n | 18726 | 5.5% |
| i | 17279 | 5.1% |
| A | 17131 | 5.0% |
| o | 16897 | 5.0% |
| h | 16897 | 5.0% |
| s | 16695 | 4.9% |
| Other values (14) | 103640 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 340496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 42750 | |
| t | 39242 | 11.5% |
| r | 26565 | 7.8% |
| e | 24674 | 7.2% |
| n | 18726 | 5.5% |
| i | 17279 | 5.1% |
| A | 17131 | 5.0% |
| o | 16897 | 5.0% |
| h | 16897 | 5.0% |
| s | 16695 | 4.9% |
| Other values (14) | 103640 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 340496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 42750 | |
| t | 39242 | 11.5% |
| r | 26565 | 7.8% |
| e | 24674 | 7.2% |
| n | 18726 | 5.5% |
| i | 17279 | 5.1% |
| A | 17131 | 5.0% |
| o | 16897 | 5.0% |
| h | 16897 | 5.0% |
| s | 16695 | 4.9% |
| Other values (14) | 103640 |
product_id
Text
| Distinct | 10292 |
|---|---|
| Distinct (%) | 20.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 15.195009 |
| Min length | 15 |
Unique
| Unique | 1420 ? |
|---|---|
| Unique (%) | 2.8% |
Sample
| 1st row | OFF-TEN-10000025 |
|---|---|
| 2nd row | OFF-SU-10000618 |
| 3rd row | OFF-TEN-10001585 |
| 4th row | OFF-PA-10001492 |
| 5th row | FUR-FU-10003447 |
| Value | Count | Frequency (%) |
| tec-hp | 83 | 0.2% |
| off-ar-10003651 | 35 | 0.1% |
| off-ar-10003829 | 31 | 0.1% |
| off-bi-10002799 | 30 | 0.1% |
| off-bi-10003708 | 30 | 0.1% |
| fur-ch-10003354 | 28 | 0.1% |
| off-bi-10002570 | 27 | 0.1% |
| off-bi-10004140 | 25 | < 0.1% |
| off-bi-10004632 | 24 | < 0.1% |
| off-bi-10001808 | 24 | < 0.1% |
| Other values (10283) | 51036 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 179614 | |
| - | 102580 | |
| F | 77961 | |
| 1 | 77220 | |
| O | 37143 | 4.8% |
| 2 | 25593 | 3.3% |
| 3 | 25555 | 3.3% |
| 4 | 25148 | 3.2% |
| A | 20235 | 2.6% |
| C | 19282 | 2.5% |
| Other values (25) | 189021 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 779352 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 179614 | |
| - | 102580 | |
| F | 77961 | |
| 1 | 77220 | |
| O | 37143 | 4.8% |
| 2 | 25593 | 3.3% |
| 3 | 25555 | 3.3% |
| 4 | 25148 | 3.2% |
| A | 20235 | 2.6% |
| C | 19282 | 2.5% |
| Other values (25) | 189021 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 779352 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 179614 | |
| - | 102580 | |
| F | 77961 | |
| 1 | 77220 | |
| O | 37143 | 4.8% |
| 2 | 25593 | 3.3% |
| 3 | 25555 | 3.3% |
| 4 | 25148 | 3.2% |
| A | 20235 | 2.6% |
| C | 19282 | 2.5% |
| Other values (25) | 189021 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 779352 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 179614 | |
| - | 102580 | |
| F | 77961 | |
| 1 | 77220 | |
| O | 37143 | 4.8% |
| 2 | 25593 | 3.3% |
| 3 | 25555 | 3.3% |
| 4 | 25148 | 3.2% |
| A | 20235 | 2.6% |
| C | 19282 | 2.5% |
| Other values (25) | 189021 |
category
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| Office Supplies | |
|---|---|
| Technology | |
| Furniture |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.856093 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Office Supplies |
|---|---|
| 2nd row | Office Supplies |
| 3rd row | Office Supplies |
| 4th row | Office Supplies |
| 5th row | Furniture |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 31273 | |
| Technology | 10141 | 19.8% |
| Furniture | 9876 | 19.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 31273 | |
| supplies | 31273 | |
| technology | 10141 | 12.3% |
| furniture | 9876 | 12.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 82563 | |
| i | 72422 | |
| p | 62546 | |
| f | 62546 | |
| u | 51025 | 7.7% |
| c | 41414 | 6.3% |
| l | 41414 | 6.3% |
| O | 31273 | 4.7% |
| s | 31273 | 4.7% |
| S | 31273 | 4.7% |
| Other values (10) | 151640 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 659389 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 82563 | |
| i | 72422 | |
| p | 62546 | |
| f | 62546 | |
| u | 51025 | 7.7% |
| c | 41414 | 6.3% |
| l | 41414 | 6.3% |
| O | 31273 | 4.7% |
| s | 31273 | 4.7% |
| S | 31273 | 4.7% |
| Other values (10) | 151640 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 659389 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 82563 | |
| i | 72422 | |
| p | 62546 | |
| f | 62546 | |
| u | 51025 | 7.7% |
| c | 41414 | 6.3% |
| l | 41414 | 6.3% |
| O | 31273 | 4.7% |
| s | 31273 | 4.7% |
| S | 31273 | 4.7% |
| Other values (10) | 151640 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 659389 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 82563 | |
| i | 72422 | |
| p | 62546 | |
| f | 62546 | |
| u | 51025 | 7.7% |
| c | 41414 | 6.3% |
| l | 41414 | 6.3% |
| O | 31273 | 4.7% |
| s | 31273 | 4.7% |
| S | 31273 | 4.7% |
| Other values (10) | 151640 |
sub_category
Categorical
High correlation 
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| Binders | |
|---|---|
| Storage | |
| Art | |
| Paper | |
| Chairs | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.2304933 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Storage |
|---|---|
| 2nd row | Supplies |
| 3rd row | Storage |
| 4th row | Paper |
| 5th row | Furnishings |
Common Values
| Value | Count | Frequency (%) |
| Binders | 6152 | |
| Storage | 5059 | 9.9% |
| Art | 4883 | 9.5% |
| Paper | 3538 | 6.9% |
| Chairs | 3434 | 6.7% |
| Phones | 3357 | 6.5% |
| Furnishings | 3170 | 6.2% |
| Accessories | 3075 | 6.0% |
| Labels | 2606 | 5.1% |
| Envelopes | 2435 | 4.7% |
| Other values (7) | 13581 |
Length
| Value | Count | Frequency (%) |
| binders | 6152 | |
| storage | 5059 | 9.9% |
| art | 4883 | 9.5% |
| paper | 3538 | 6.9% |
| chairs | 3434 | 6.7% |
| phones | 3357 | 6.5% |
| furnishings | 3170 | 6.2% |
| accessories | 3075 | 6.0% |
| labels | 2606 | 5.1% |
| envelopes | 2435 | 4.7% |
| Other values (7) | 13581 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 51961 | |
| e | 47733 | |
| r | 33954 | 9.2% |
| i | 26890 | 7.3% |
| n | 23945 | 6.5% |
| a | 23570 | 6.4% |
| o | 20971 | 5.7% |
| p | 16556 | 4.5% |
| t | 12362 | 3.3% |
| c | 11802 | 3.2% |
| Other values (18) | 101108 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 370852 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 51961 | |
| e | 47733 | |
| r | 33954 | 9.2% |
| i | 26890 | 7.3% |
| n | 23945 | 6.5% |
| a | 23570 | 6.4% |
| o | 20971 | 5.7% |
| p | 16556 | 4.5% |
| t | 12362 | 3.3% |
| c | 11802 | 3.2% |
| Other values (18) | 101108 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 370852 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 51961 | |
| e | 47733 | |
| r | 33954 | 9.2% |
| i | 26890 | 7.3% |
| n | 23945 | 6.5% |
| a | 23570 | 6.4% |
| o | 20971 | 5.7% |
| p | 16556 | 4.5% |
| t | 12362 | 3.3% |
| c | 11802 | 3.2% |
| Other values (18) | 101108 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 370852 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 51961 | |
| e | 47733 | |
| r | 33954 | 9.2% |
| i | 26890 | 7.3% |
| n | 23945 | 6.5% |
| a | 23570 | 6.4% |
| o | 20971 | 5.7% |
| p | 16556 | 4.5% |
| t | 12362 | 3.3% |
| c | 11802 | 3.2% |
| Other values (18) | 101108 |
product_name
Text
| Distinct | 3788 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
Length
| Max length | 127 |
|---|---|
| Median length | 89 |
| Mean length | 30.856931 |
| Min length | 5 |
Unique
| Unique | 98 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Tenex Lockers, Blue |
|---|---|
| 2nd row | Acme Trimmer, High Speed |
| 3rd row | Tenex Box, Single Width |
| 4th row | Enermax Note Cards, Premium |
| 5th row | Eldon Light Bulb, Duo Pack |
| Value | Count | Frequency (%) |
| labels | 2385 | 1.0% |
| recycled | 2291 | 1.0% |
| color | 2187 | 0.9% |
| with | 2177 | 0.9% |
| set | 2106 | 0.9% |
| blue | 2092 | 0.9% |
| durable | 2072 | 0.9% |
| black | 2055 | 0.9% |
| avery | 1920 | 0.8% |
| clear | 1893 | 0.8% |
| Other values (2826) | 210320 |
Most occurring characters
| Value | Count | Frequency (%) |
| 179838 | 11.4% | |
| e | 154618 | 9.8% |
| a | 94421 | 6.0% |
| r | 91563 | 5.8% |
| o | 88370 | 5.6% |
| l | 79902 | 5.0% |
| i | 79392 | 5.0% |
| n | 68089 | 4.3% |
| t | 62491 | 3.9% |
| s | 60638 | 3.8% |
| Other values (75) | 623330 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1582652 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 179838 | 11.4% | |
| e | 154618 | 9.8% |
| a | 94421 | 6.0% |
| r | 91563 | 5.8% |
| o | 88370 | 5.6% |
| l | 79902 | 5.0% |
| i | 79392 | 5.0% |
| n | 68089 | 4.3% |
| t | 62491 | 3.9% |
| s | 60638 | 3.8% |
| Other values (75) | 623330 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1582652 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 179838 | 11.4% | |
| e | 154618 | 9.8% |
| a | 94421 | 6.0% |
| r | 91563 | 5.8% |
| o | 88370 | 5.6% |
| l | 79902 | 5.0% |
| i | 79392 | 5.0% |
| n | 68089 | 4.3% |
| t | 62491 | 3.9% |
| s | 60638 | 3.8% |
| Other values (75) | 623330 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1582652 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 179838 | 11.4% | |
| e | 154618 | 9.8% |
| a | 94421 | 6.0% |
| r | 91563 | 5.8% |
| o | 88370 | 5.6% |
| l | 79902 | 5.0% |
| i | 79392 | 5.0% |
| n | 68089 | 4.3% |
| t | 62491 | 3.9% |
| s | 60638 | 3.8% |
| Other values (75) | 623330 |
sales
Real number (ℝ)
High correlation 
| Distinct | 2246 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 246.49844 |
| Minimum | 0 |
|---|---|
| Maximum | 22638 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 400.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 31 |
| median | 85 |
| Q3 | 251 |
| 95-th percentile | 1016 |
| Maximum | 22638 |
| Range | 22638 |
| Interquartile range (IQR) | 220 |
Descriptive statistics
| Standard deviation | 487.56717 |
|---|---|
| Coefficient of variation (CV) | 1.9779727 |
| Kurtosis | 176.72302 |
| Mean | 246.49844 |
| Median Absolute Deviation (MAD) | 67 |
| Skewness | 8.1379805 |
| Sum | 12642905 |
| Variance | 237721.75 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13 | 589 | 1.1% |
| 11 | 550 | 1.1% |
| 14 | 527 | 1.0% |
| 19 | 523 | 1.0% |
| 17 | 520 | 1.0% |
| 15 | 518 | 1.0% |
| 12 | 512 | 1.0% |
| 16 | 505 | 1.0% |
| 9 | 498 | 1.0% |
| 22 | 478 | 0.9% |
| Other values (2236) | 46070 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 44 | 0.1% |
| 2 | 142 | 0.3% |
| 3 | 274 | |
| 4 | 306 | |
| 5 | 372 | |
| 6 | 433 | |
| 7 | 411 | |
| 8 | 413 | |
| 9 | 498 |
| Value | Count | Frequency (%) |
| 22638 | 1 | |
| 17500 | 1 | |
| 14000 | 1 | |
| 11200 | 1 | |
| 10500 | 1 | |
| 9893 | 1 | |
| 9450 | 1 | |
| 9100 | 1 | |
| 8750 | 1 | |
| 8400 | 1 |
quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4765451 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 400.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2787663 |
|---|---|
| Coefficient of variation (CV) | 0.65546864 |
| Kurtosis | 2.2758887 |
| Mean | 3.4765451 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.3603677 |
| Sum | 178312 |
| Variance | 5.1927759 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 12748 | |
| 3 | 9682 | |
| 1 | 8963 | |
| 4 | 6385 | |
| 5 | 4882 | 9.5% |
| 6 | 3020 | 5.9% |
| 7 | 2385 | 4.7% |
| 8 | 1361 | 2.7% |
| 9 | 987 | 1.9% |
| 10 | 276 | 0.5% |
| Other values (4) | 601 | 1.2% |
| Value | Count | Frequency (%) |
| 1 | 8963 | |
| 2 | 12748 | |
| 3 | 9682 | |
| 4 | 6385 | |
| 5 | 4882 | 9.5% |
| 6 | 3020 | 5.9% |
| 7 | 2385 | 4.7% |
| 8 | 1361 | 2.7% |
| 9 | 987 | 1.9% |
| 10 | 276 | 0.5% |
| Value | Count | Frequency (%) |
| 14 | 186 | 0.4% |
| 13 | 83 | 0.2% |
| 12 | 176 | 0.3% |
| 11 | 156 | 0.3% |
| 10 | 276 | 0.5% |
| 9 | 987 | 1.9% |
| 8 | 1361 | 2.7% |
| 7 | 2385 | |
| 6 | 3020 | |
| 5 | 4882 |
discount
Real number (ℝ)
High correlation  Zeros 
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14290755 |
| Minimum | 0 |
|---|---|
| Maximum | 0.85 |
| Zeros | 29009 |
| Zeros (%) | 56.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 400.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.2 |
| 95-th percentile | 0.6 |
| Maximum | 0.85 |
| Range | 0.85 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.21227993 |
|---|---|
| Coefficient of variation (CV) | 1.4854354 |
| Kurtosis | 0.71668241 |
| Mean | 0.14290755 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.3877746 |
| Sum | 7329.728 |
| Variance | 0.045062769 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 29009 | |
| 0.2 | 4998 | 9.7% |
| 0.1 | 4068 | 7.9% |
| 0.4 | 3177 | 6.2% |
| 0.6 | 2006 | 3.9% |
| 0.7 | 1786 | 3.5% |
| 0.5 | 1633 | 3.2% |
| 0.17 | 735 | 1.4% |
| 0.47 | 725 | 1.4% |
| 0.15 | 541 | 1.1% |
| Other values (17) | 2612 | 5.1% |
| Value | Count | Frequency (%) |
| 0 | 29009 | |
| 0.002 | 461 | 0.9% |
| 0.07 | 150 | 0.3% |
| 0.1 | 4068 | 7.9% |
| 0.15 | 541 | 1.1% |
| 0.17 | 735 | 1.4% |
| 0.2 | 4998 | 9.7% |
| 0.202 | 41 | 0.1% |
| 0.25 | 198 | 0.4% |
| 0.27 | 388 | 0.8% |
| Value | Count | Frequency (%) |
| 0.85 | 2 | < 0.1% |
| 0.8 | 316 | 0.6% |
| 0.7 | 1786 | |
| 0.65 | 17 | < 0.1% |
| 0.602 | 23 | < 0.1% |
| 0.6 | 2006 | |
| 0.57 | 12 | < 0.1% |
| 0.55 | 10 | < 0.1% |
| 0.5 | 1633 | |
| 0.47 | 725 | 1.4% |
profit
Real number (ℝ)
High correlation  Zeros 
| Distinct | 24575 |
|---|---|
| Distinct (%) | 47.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.64174 |
| Minimum | -6599.978 |
|---|---|
| Maximum | 8399.976 |
| Zeros | 668 |
| Zeros (%) | 1.3% |
| Negative | 12543 |
| Negative (%) | 24.5% |
| Memory size | 400.8 KiB |
Quantile statistics
| Minimum | -6599.978 |
|---|---|
| 5-th percentile | -83.87784 |
| Q1 | 0 |
| median | 9.24 |
| Q3 | 36.81 |
| 95-th percentile | 211.5 |
| Maximum | 8399.976 |
| Range | 14999.954 |
| Interquartile range (IQR) | 36.81 |
Descriptive statistics
| Standard deviation | 174.42411 |
|---|---|
| Coefficient of variation (CV) | 6.0898575 |
| Kurtosis | 290.90013 |
| Mean | 28.64174 |
| Median Absolute Deviation (MAD) | 15.96 |
| Skewness | 4.1581878 |
| Sum | 1469034.8 |
| Variance | 30423.771 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 668 | 1.3% |
| 4.32 | 70 | 0.1% |
| 3.96 | 69 | 0.1% |
| 7.92 | 67 | 0.1% |
| 2.64 | 63 | 0.1% |
| 2.88 | 60 | 0.1% |
| 6.84 | 57 | 0.1% |
| 9 | 56 | 0.1% |
| 0.48 | 55 | 0.1% |
| 3.42 | 55 | 0.1% |
| Other values (24565) | 50070 |
| Value | Count | Frequency (%) |
| -6599.978 | 1 | |
| -4088.376 | 1 | |
| -3839.9904 | 1 | |
| -3701.8928 | 1 | |
| -3399.98 | 1 | |
| -3059.82 | 1 | |
| -3009.435 | 1 | |
| -2929.4845 | 1 | |
| -2750.28 | 1 | |
| -2639.9912 | 1 |
| Value | Count | Frequency (%) |
| 8399.976 | 1 | |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 4946.37 | 1 | |
| 4630.4755 | 1 | |
| 3979.08 | 1 | |
| 3919.9888 | 1 | |
| 3177.475 | 1 | |
| 2939.31 | 1 | |
| 2817.99 | 1 |
shipping_cost
Real number (ℝ)
High correlation 
| Distinct | 10037 |
|---|---|
| Distinct (%) | 19.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.375915 |
| Minimum | 0 |
|---|---|
| Maximum | 933.57 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 400.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.61 |
| Q1 | 2.61 |
| median | 7.79 |
| Q3 | 24.45 |
| 95-th percentile | 111.4095 |
| Maximum | 933.57 |
| Range | 933.57 |
| Interquartile range (IQR) | 21.84 |
Descriptive statistics
| Standard deviation | 57.296804 |
|---|---|
| Coefficient of variation (CV) | 2.1723153 |
| Kurtosis | 50.020158 |
| Mean | 26.375915 |
| Median Absolute Deviation (MAD) | 6.41 |
| Skewness | 5.8632264 |
| Sum | 1352820.7 |
| Variance | 3282.9237 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.86 | 76 | 0.1% |
| 1.26 | 75 | 0.1% |
| 0.71 | 75 | 0.1% |
| 1.36 | 74 | 0.1% |
| 0.35 | 73 | 0.1% |
| 0.79 | 71 | 0.1% |
| 0.94 | 71 | 0.1% |
| 1.04 | 71 | 0.1% |
| 0.97 | 70 | 0.1% |
| 0.69 | 70 | 0.1% |
| Other values (10027) | 50564 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 0.01 | 6 | < 0.1% |
| 0.02 | 9 | < 0.1% |
| 0.03 | 9 | < 0.1% |
| 0.04 | 14 | |
| 0.05 | 19 | |
| 0.06 | 18 | |
| 0.07 | 13 | |
| 0.08 | 17 | |
| 0.09 | 23 |
| Value | Count | Frequency (%) |
| 933.57 | 1 | |
| 923.63 | 1 | |
| 915.49 | 1 | |
| 910.16 | 1 | |
| 903.04 | 1 | |
| 897.35 | 1 | |
| 894.77 | 1 | |
| 878.38 | 1 | |
| 867.69 | 1 | |
| 865.74 | 1 |
order_priority
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| Medium | |
|---|---|
| High | |
| Critical | |
| Low | 2424 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.4070969 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Medium |
|---|---|
| 2nd row | Medium |
| 3rd row | High |
| 4th row | High |
| 5th row | Medium |
Common Values
| Value | Count | Frequency (%) |
| Medium | 29433 | |
| High | 15501 | |
| Critical | 3932 | 7.7% |
| Low | 2424 | 4.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| medium | 29433 | |
| high | 15501 | |
| critical | 3932 | 7.7% |
| low | 2424 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 52798 | |
| M | 29433 | |
| d | 29433 | |
| u | 29433 | |
| m | 29433 | |
| e | 29433 | |
| H | 15501 | 5.6% |
| g | 15501 | 5.6% |
| h | 15501 | 5.6% |
| c | 3932 | 1.4% |
| Other values (8) | 26932 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 277330 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 52798 | |
| M | 29433 | |
| d | 29433 | |
| u | 29433 | |
| m | 29433 | |
| e | 29433 | |
| H | 15501 | 5.6% |
| g | 15501 | 5.6% |
| h | 15501 | 5.6% |
| c | 3932 | 1.4% |
| Other values (8) | 26932 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 277330 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 52798 | |
| M | 29433 | |
| d | 29433 | |
| u | 29433 | |
| m | 29433 | |
| e | 29433 | |
| H | 15501 | 5.6% |
| g | 15501 | 5.6% |
| h | 15501 | 5.6% |
| c | 3932 | 1.4% |
| Other values (8) | 26932 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 277330 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 52798 | |
| M | 29433 | |
| d | 29433 | |
| u | 29433 | |
| m | 29433 | |
| e | 29433 | |
| H | 15501 | 5.6% |
| g | 15501 | 5.6% |
| h | 15501 | 5.6% |
| c | 3932 | 1.4% |
| Other values (8) | 26932 |
year
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.8 KiB |
| 2014 | |
|---|---|
| 2013 | |
| 2012 | |
| 2011 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2011 |
|---|---|
| 2nd row | 2011 |
| 3rd row | 2011 |
| 4th row | 2011 |
| 5th row | 2011 |
Common Values
| Value | Count | Frequency (%) |
| 2014 | 17531 | |
| 2013 | 13799 | |
| 2012 | 10962 | |
| 2011 | 8998 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2014 | 17531 | |
| 2013 | 13799 | |
| 2012 | 10962 | |
| 2011 | 8998 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 62252 | |
| 1 | 60288 | |
| 0 | 51290 | |
| 4 | 17531 | 8.5% |
| 3 | 13799 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 205160 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 62252 | |
| 1 | 60288 | |
| 0 | 51290 | |
| 4 | 17531 | 8.5% |
| 3 | 13799 | 6.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 205160 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 62252 | |
| 1 | 60288 | |
| 0 | 51290 | |
| 4 | 17531 | 8.5% |
| 3 | 13799 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 205160 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 62252 | |
| 1 | 60288 | |
| 0 | 51290 | |
| 4 | 17531 | 8.5% |
| 3 | 13799 | 6.7% |
Interactions
Correlations
| category | discount | market | order_priority | profit | quantity | region | sales | segment | ship_mode | shipping_cost | sub_category | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| category | 1.000 | 0.185 | 0.073 | 0.003 | 0.056 | 0.015 | 0.056 | 0.062 | 0.000 | 0.000 | 0.156 | 1.000 | 0.002 |
| discount | 0.185 | 1.000 | 0.348 | 0.011 | -0.596 | 0.018 | 0.335 | -0.100 | 0.000 | 0.019 | -0.094 | 0.159 | 0.020 |
| market | 0.073 | 0.348 | 1.000 | 0.013 | 0.010 | 0.157 | 0.882 | 0.021 | 0.009 | 0.014 | 0.032 | 0.128 | 0.028 |
| order_priority | 0.003 | 0.011 | 0.013 | 1.000 | 0.009 | 0.008 | 0.027 | 0.000 | 0.019 | 0.284 | 0.099 | 0.004 | 0.017 |
| profit | 0.056 | -0.596 | 0.010 | 0.009 | 1.000 | 0.202 | 0.010 | 0.490 | 0.000 | 0.011 | 0.450 | 0.058 | 0.000 |
| quantity | 0.015 | 0.018 | 0.157 | 0.008 | 0.202 | 1.000 | 0.129 | 0.416 | 0.000 | 0.008 | 0.379 | 0.016 | 0.010 |
| region | 0.056 | 0.335 | 0.882 | 0.027 | 0.010 | 0.129 | 1.000 | 0.019 | 0.012 | 0.026 | 0.028 | 0.069 | 0.022 |
| sales | 0.062 | -0.100 | 0.021 | 0.000 | 0.490 | 0.416 | 0.019 | 1.000 | 0.000 | 0.000 | 0.913 | 0.061 | 0.000 |
| segment | 0.000 | 0.000 | 0.009 | 0.019 | 0.000 | 0.000 | 0.012 | 0.000 | 1.000 | 0.011 | 0.000 | 0.012 | 0.014 |
| ship_mode | 0.000 | 0.019 | 0.014 | 0.284 | 0.011 | 0.008 | 0.026 | 0.000 | 0.011 | 1.000 | 0.074 | 0.011 | 0.007 |
| shipping_cost | 0.156 | -0.094 | 0.032 | 0.099 | 0.450 | 0.379 | 0.028 | 0.913 | 0.000 | 0.074 | 1.000 | 0.112 | 0.014 |
| sub_category | 1.000 | 0.159 | 0.128 | 0.004 | 0.058 | 0.016 | 0.069 | 0.061 | 0.012 | 0.011 | 0.112 | 1.000 | 0.005 |
| year | 0.002 | 0.020 | 0.028 | 0.017 | 0.000 | 0.010 | 0.022 | 0.000 | 0.014 | 0.007 | 0.014 | 0.005 | 1.000 |
Missing values
Sample
| order_id | order_date | ship_date | ship_mode | customer_name | segment | state | country | market | region | product_id | category | sub_category | product_name | sales | quantity | discount | profit | shipping_cost | order_priority | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AG-2011-2040 | 2011-01-01 00:00:00 | 2011-06-01 00:00:00 | Standard Class | Toby Braunhardt | Consumer | Constantine | Algeria | Africa | Africa | OFF-TEN-10000025 | Office Supplies | Storage | Tenex Lockers, Blue | 408 | 2 | 0.0 | 106.140 | 35.46 | Medium | 2011 |
| 1 | IN-2011-47883 | 2011-01-01 00:00:00 | 2011-08-01 00:00:00 | Standard Class | Joseph Holt | Consumer | New South Wales | Australia | APAC | Oceania | OFF-SU-10000618 | Office Supplies | Supplies | Acme Trimmer, High Speed | 120 | 3 | 0.1 | 36.036 | 9.72 | Medium | 2011 |
| 2 | HU-2011-1220 | 2011-01-01 00:00:00 | 2011-05-01 00:00:00 | Second Class | Annie Thurman | Consumer | Budapest | Hungary | EMEA | EMEA | OFF-TEN-10001585 | Office Supplies | Storage | Tenex Box, Single Width | 66 | 4 | 0.0 | 29.640 | 8.17 | High | 2011 |
| 3 | IT-2011-3647632 | 2011-01-01 00:00:00 | 2011-05-01 00:00:00 | Second Class | Eugene Moren | Home Office | Stockholm | Sweden | EU | North | OFF-PA-10001492 | Office Supplies | Paper | Enermax Note Cards, Premium | 45 | 3 | 0.5 | -26.055 | 4.82 | High | 2011 |
| 4 | IN-2011-47883 | 2011-01-01 00:00:00 | 2011-08-01 00:00:00 | Standard Class | Joseph Holt | Consumer | New South Wales | Australia | APAC | Oceania | FUR-FU-10003447 | Furniture | Furnishings | Eldon Light Bulb, Duo Pack | 114 | 5 | 0.1 | 37.770 | 4.70 | Medium | 2011 |
| 5 | IN-2011-47883 | 2011-01-01 00:00:00 | 2011-08-01 00:00:00 | Standard Class | Joseph Holt | Consumer | New South Wales | Australia | APAC | Oceania | OFF-PA-10001968 | Office Supplies | Paper | Eaton Computer Printout Paper, 8.5 x 11 | 55 | 2 | 0.1 | 15.342 | 1.80 | Medium | 2011 |
| 6 | CA-2011-1510 | 2011-02-01 00:00:00 | 2011-06-01 00:00:00 | Standard Class | Magdelene Morse | Consumer | Ontario | Canada | Canada | Canada | TEC-OKI-10002750 | Technology | Machines | Okidata Inkjet, Wireless | 314 | 1 | 0.0 | 3.120 | 24.10 | Medium | 2011 |
| 7 | IN-2011-79397 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | Same Day | Kean Nguyen | Corporate | New South Wales | Australia | APAC | Oceania | OFF-AP-10000304 | Office Supplies | Appliances | Hoover Microwave, White | 276 | 1 | 0.1 | 110.412 | 125.32 | Critical | 2011 |
| 8 | ID-2011-80230 | 2011-03-01 00:00:00 | 2011-09-01 00:00:00 | Standard Class | Ken Lonsdale | Consumer | Auckland | New Zealand | APAC | Oceania | TEC-CO-10004182 | Technology | Copiers | Hewlett Wireless Fax, Laser | 912 | 4 | 0.4 | -319.464 | 107.10 | Low | 2011 |
| 9 | IZ-2011-4680 | 2011-03-01 00:00:00 | 2011-07-01 00:00:00 | Standard Class | Lindsay Williams | Corporate | Ninawa | Iraq | EMEA | EMEA | FUR-NOV-10002791 | Furniture | Chairs | Novimex Swivel Stool, Set of Two | 667 | 4 | 0.0 | 253.320 | 81.26 | High | 2011 |
| order_id | order_date | ship_date | ship_mode | customer_name | segment | state | country | market | region | product_id | category | sub_category | product_name | sales | quantity | discount | profit | shipping_cost | order_priority | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51280 | TZ-2014-8220 | 31-12-2014 | 2015-06-01 00:00:00 | Standard Class | Christine Kargatis | Home Office | Dar Es Salaam | Tanzania | Africa | Africa | OFF-HAR-10001531 | Office Supplies | Labels | Harbour Creations Removable Labels, Adjustable | 50 | 6 | 0.0 | 6.8400 | 2.15 | Medium | 2014 |
| 51281 | CA-2014-115427 | 31-12-2014 | 2015-04-01 00:00:00 | Standard Class | Erica Bern | Corporate | California | United States | US | West | OFF-BI-10004632 | Office Supplies | Binders | GBC Binding covers | 21 | 2 | 0.2 | 6.4750 | 2.06 | Medium | 2014 |
| 51282 | UP-2014-4410 | 31-12-2014 | 2015-04-01 00:00:00 | Standard Class | Guy Thornton | Consumer | Zaporizhzhya | Ukraine | EMEA | EMEA | OFF-AVE-10003558 | Office Supplies | Labels | Avery Round Labels, Alphabetical | 28 | 4 | 0.0 | 6.1200 | 1.70 | Medium | 2014 |
| 51283 | IN-2014-23754 | 31-12-2014 | 2015-07-01 00:00:00 | Standard Class | Kalyca Meade | Corporate | Guangdong | China | APAC | North Asia | OFF-PA-10004727 | Office Supplies | Paper | Eaton Note Cards, 8.5 x 11 | 79 | 3 | 0.0 | 25.3800 | 1.41 | Medium | 2014 |
| 51284 | MX-2014-108574 | 31-12-2014 | 2015-04-01 00:00:00 | Standard Class | Julia Barnett | Home Office | Tamaulipas | Mexico | LATAM | North | OFF-LA-10004969 | Office Supplies | Labels | Novimex Legal Exhibit Labels, Adjustable | 17 | 3 | 0.0 | 0.6600 | 1.32 | Medium | 2014 |
| 51285 | CA-2014-115427 | 31-12-2014 | 2015-04-01 00:00:00 | Standard Class | Erica Bern | Corporate | California | United States | US | West | OFF-BI-10002103 | Office Supplies | Binders | Cardinal Slant-D Ring Binder, Heavy Gauge Vinyl | 14 | 2 | 0.2 | 4.5188 | 0.89 | Medium | 2014 |
| 51286 | MO-2014-2560 | 31-12-2014 | 2015-05-01 00:00:00 | Standard Class | Liz Preis | Consumer | Souss-Massa-Draâ | Morocco | Africa | Africa | OFF-WIL-10001069 | Office Supplies | Binders | Wilson Jones Hole Reinforcements, Clear | 4 | 1 | 0.0 | 0.4200 | 0.49 | Medium | 2014 |
| 51287 | MX-2014-110527 | 31-12-2014 | 2015-02-01 00:00:00 | Second Class | Charlotte Melton | Consumer | Managua | Nicaragua | LATAM | Central | OFF-LA-10004182 | Office Supplies | Labels | Hon Color Coded Labels, 5000 Label Set | 26 | 3 | 0.0 | 12.3600 | 0.35 | Medium | 2014 |
| 51288 | MX-2014-114783 | 31-12-2014 | 2015-06-01 00:00:00 | Standard Class | Tamara Dahlen | Consumer | Chihuahua | Mexico | LATAM | North | OFF-LA-10000413 | Office Supplies | Labels | Hon Legal Exhibit Labels, Alphabetical | 7 | 1 | 0.0 | 0.5600 | 0.20 | Medium | 2014 |
| 51289 | CA-2014-156720 | 31-12-2014 | 2015-04-01 00:00:00 | Standard Class | Jill Matthias | Consumer | Colorado | United States | US | West | OFF-FA-10003472 | Office Supplies | Fasteners | Bagged Rubber Bands | 3 | 3 | 0.2 | -0.6048 | 0.17 | Medium | 2014 |